UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C4It+RU46MY+R82WisWduo3MiNvvrUSvlIgoUndlfoI='
WHERE
key_id = 'e0246b5d3d95fd0a1a4da7264e4fbe665a04a0ff9951a70b0fa775de84d04a81'
AND (
token = 'C4It+RU46MY+R82WisWduo3MiNvvrUSvlIgoUndlfoI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)