UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pxDuWviaamEJ0GCQTnuUawj0lcWRRs2V55xnY2mF8c0='
WHERE
key_id = '8c44d2bf437d84f0e4819e19cb09be6f89150c4dfac1b7b18111dd0a795f5a7c'
AND (
token = 'pxDuWviaamEJ0GCQTnuUawj0lcWRRs2V55xnY2mF8c0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)