UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'd/p8GC5ojeop2FhlU1Rx5aBtQgOfRw4fPI5LcAzleAg='
WHERE
key_id = '4f23882fe200951d88a82d9e632d90271e4b83cf59465cf2b239140e74a9bdde'
AND (
token = 'd/p8GC5ojeop2FhlU1Rx5aBtQgOfRw4fPI5LcAzleAg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)