UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pecMQAsdBeo0almdwzlCtr7doYVE8zz+dia+F6Q59aE='
WHERE
key_id = 'a607595bf4d4e26d7a69f54dbb3ed61265771a26b04d65d22f013643fc6c7dad'
AND (
token = 'pecMQAsdBeo0almdwzlCtr7doYVE8zz+dia+F6Q59aE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)