UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nyFx8JwUxD81wA9SZYABpBxWXY7jeY99e7Prl7wCtjo='
WHERE
key_id = '7ba9f5454f2a04c98dd4ed59b162c263256d2091f85fad190386f565d0e0d8c5'
AND (
token = 'nyFx8JwUxD81wA9SZYABpBxWXY7jeY99e7Prl7wCtjo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)