UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0QcYjOqGESdF468sF2ujPQZJ1YfZUqM8q7o3fP0Ugfw='
WHERE
key_id = '86bfc4a5f996e58583ed55834ecf90f86ff9fc18faef14e8404d30ee9dd62abe'
AND (
token = '0QcYjOqGESdF468sF2ujPQZJ1YfZUqM8q7o3fP0Ugfw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)