UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7L9+SftK5mzawz7Dq9D4RdcVNGCqxoDw9Z9ra+ZzuB8='
WHERE
key_id = '64e09796a6ea3c61190edd3ab495c0fc2f6c224da096f9e2213fd942df0846ab'
AND (
token = '7L9+SftK5mzawz7Dq9D4RdcVNGCqxoDw9Z9ra+ZzuB8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)