UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zmqU1NwwhuqCiyJMH/7dAZkhcntaq9KXhCBVODzYZco='
WHERE
key_id = '2d7c2366381adbe01c2e9f19084f639c26760964867cf9e132470f940bcee007'
AND (
token = 'zmqU1NwwhuqCiyJMH/7dAZkhcntaq9KXhCBVODzYZco='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)