UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8JyL2+wEv+2KeIdMSmrS4sawTinbyfxtdXHtpkFb/rY='
WHERE
key_id = 'c20797b24a69dea743272359be4bb84e35f3774dffbafc39b0f6f1737bb0bb16'
AND (
token = '8JyL2+wEv+2KeIdMSmrS4sawTinbyfxtdXHtpkFb/rY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)