UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QNsKlGxV9sYOkm2vQcewg0n1paflhNLaSBDlCfH7Slk='
WHERE
key_id = '946af948fa387b408b2d10f392d5a87907f92df57c30e97ee48d63a7adb4529b'
AND (
token = 'QNsKlGxV9sYOkm2vQcewg0n1paflhNLaSBDlCfH7Slk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)