UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xPT3qv/oOg+n01a1GU27sWMidSxL6ULpHROQiAuCOE4='
WHERE
key_id = 'cb5300fe3cdb1e17c7c23a3e5abc58d7813315a313f9971b07331b1ef47cf5f0'
AND (
token = 'xPT3qv/oOg+n01a1GU27sWMidSxL6ULpHROQiAuCOE4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)