UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kxNWbhZ0SCB3RJg+By8P0gTgxrxRpb6Yq4hmRoPaZmU='
WHERE
key_id = 'ae3ebcd3b8801bf45e05796787667688a6b3229f4c46321a180edd2c7aa476c8'
AND (
token = 'kxNWbhZ0SCB3RJg+By8P0gTgxrxRpb6Yq4hmRoPaZmU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)