UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'by7ijN9wV5iaLauJSJyOTHM3GYSmEXwGFz4dN/CBKT4='
WHERE
key_id = 'f8e76e04b90580cb8754ef52f2c7b3cba5609974de86a528296149192cb86a76'
AND (
token = 'by7ijN9wV5iaLauJSJyOTHM3GYSmEXwGFz4dN/CBKT4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)