UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6QkBDIeTlC6tDd7HJy0mf8o0CoXjx5Wh1TX+aPMrQXA='
WHERE
key_id = 'b8bed6333b0fd18c89b3631ab0c1b5ce67748a5b42ff18ff9f9811b568212c02'
AND (
token = '6QkBDIeTlC6tDd7HJy0mf8o0CoXjx5Wh1TX+aPMrQXA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)