UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hvH+0c9C+ifekIr6SlgDTErEqoyVlKxNdSmE+1e9fgU='
WHERE
key_id = '3b96aca0e53b03894628da521744795bb7743ec0389c42c25752e5aa2acc194a'
AND (
token = 'hvH+0c9C+ifekIr6SlgDTErEqoyVlKxNdSmE+1e9fgU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)