UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'ZlSETLC8T339BBQ2ubxfPR/cDtBc9Tsq6iN6wwQ1QIU=' 
WHERE 
  key_id = '5dbc8a1aa91a1a34b41c866efe9a9d69d7df37de2aca44f4cbfe5cf17cddc6c2' 
  AND (
    token = 'ZlSETLC8T339BBQ2ubxfPR/cDtBc9Tsq6iN6wwQ1QIU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00025