UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'k6Mgea1r+KUW8QN2j96yYYhKRZrDRcFINkTHCRRs3Mg='
WHERE
key_id = '41f021c74053f2dded7443bbae93f39f4481cae8d7c33c98d099d41bb5b50273'
AND (
token = 'k6Mgea1r+KUW8QN2j96yYYhKRZrDRcFINkTHCRRs3Mg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)