UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'S3n28pHfQzvz9ku5iow86c8YH6IzJnKjJGBJI6in3M0='
WHERE
key_id = '3507915f681e0f9a604fd4145df42364fcd148e252ddd0eea97e0050bcc2598d'
AND (
token = 'S3n28pHfQzvz9ku5iow86c8YH6IzJnKjJGBJI6in3M0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)