UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EW6pUYWqusCPUXP27sE6RF/q/0DYPJdD7wlwKDPWNuw='
WHERE
key_id = '90e2927a33e41d023cea57cde5c2b5d1d91b95e90cbad6c8e90fd79e2f3adae4'
AND (
token = 'EW6pUYWqusCPUXP27sE6RF/q/0DYPJdD7wlwKDPWNuw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)