UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9s8a/xPh4EZFf7htNWh64KFjFkfCkBvrOcZltx0uqbg='
WHERE
key_id = '78b8d3eabcc4c77c89909b798b3111e433905c6770c6c2958b8111384920d389'
AND (
token = '9s8a/xPh4EZFf7htNWh64KFjFkfCkBvrOcZltx0uqbg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)