UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '/DsxwnEWceL3s2MKOinleKeI31tTYHgttftoOfiIij8=' 
WHERE 
  key_id = 'd119beda2bbd72bb829368a92f8647bd2ea684c0a2dc7d0d586ee6b61d67cdca' 
  AND (
    token = '/DsxwnEWceL3s2MKOinleKeI31tTYHgttftoOfiIij8=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00033