UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'RpIMC/P8NWV//SEQzY5BdNPsE4rorl3yu7L7AuZCmrE=' 
WHERE 
  key_id = '216a9766ee8f63a057af165e4773f13f93a339f0065f5a203530cbf7a5f5b44e' 
  AND (
    token = 'RpIMC/P8NWV//SEQzY5BdNPsE4rorl3yu7L7AuZCmrE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00051