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