UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SteHy6llG2K7HRnu0zZlG4dHUKvcWCM6SFIQDL8kXjA='
WHERE
key_id = 'b3a60da3cb43ef633bf46f8f3b2cf9099173845dab8344802dd4223392ae73bd'
AND (
token = 'SteHy6llG2K7HRnu0zZlG4dHUKvcWCM6SFIQDL8kXjA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)