UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4N4FnokPs792Jk4aQ+kds3Qxn64iBYpq3nTubrJxd8M='
WHERE
key_id = 'd93c47b2b764d4e89ff65ce1ac83920c9a9129b0fd864ddc1de572452a1abd4b'
AND (
token = '4N4FnokPs792Jk4aQ+kds3Qxn64iBYpq3nTubrJxd8M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)