UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NBQZ6gphLrhRCtuTAXBzdmCGFn8/E8bnk7DWSuI+J68='
WHERE
key_id = 'f69420a300a4cefd7837114e73f9342a22348f7ad75c59029fcc1018deeb9274'
AND (
token = 'NBQZ6gphLrhRCtuTAXBzdmCGFn8/E8bnk7DWSuI+J68='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)