UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'k75yIkLCQdv/vVId47L3pI9Cda76YjpzmTUSRCJ3xYo='
WHERE
key_id = 'c0c9bdcfc2bc0e6d392afa64aeca60734b6e1b97ec44c0bd8b031123a21ed361'
AND (
token = 'k75yIkLCQdv/vVId47L3pI9Cda76YjpzmTUSRCJ3xYo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)