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