UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qgTABtf8dWFAlJaE1Or4JPyIwqc2Wm3NJDOyAsRUJ6Y='
WHERE
key_id = 'c9b1b42d6a8acee9f9f0325fc5dde73612207db52f24c066543dfe897843571b'
AND (
token = 'qgTABtf8dWFAlJaE1Or4JPyIwqc2Wm3NJDOyAsRUJ6Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)